Pick Conversion Codes.txt

The MultiValue conversion codes listed in the following table can be used in various ways, including the following:

The MVBasic ICONV, ICONVS, OCONV, and OCONVS functions.
The MVBasic FMT and FMTS functions.
Implicit formatting with the MVBasic DISPLAY, CRT, and PRINT statements.
The CMQL query language CONV (or CONVERSION) clause.
The VOC Attribute 7 value.

Code(s)        Present      Description
A              OCONV        Arithmetic and equality functions
BB             -            Bit conversion (binary)
BX             -            Bit conversion (hexadecimal)
C              OCONV        Concatenation
D              ICONV/OCONV  Date conversion
DI             ICONV/OCONV  Internal date conversion
ECS            -            Extended character set conversion
F              -            Mathematical functions
G              ICONV/OCONV  Group extraction
L              ICONV/OCONV  Length function
MB             -            Binary conversion
MCA            ICONV/OCONV  Masked character alphabetic
MC/A           OCONV        Masked character exclude alphabetic
MCAX           ICONV/OCONV  Masked character to ASCII conversion
MCB            ICONV/OCONV  Masked character both alphabetic and numeric
MCBA           OCONV        Binary to ASCII conversion
MC/B           OCONV        Masked character exclude both alphabetic and numeric
MCD            OCONV        Decimal to hexadecimal conversion
MCDX           ICONV/OCONV  Decimal to hexadecimal conversion
MCL            ICONV/OCONV  Masked lowercase conversion
MCU            ICONV/OCONV  Masked uppercase conversion
MCM            -            Masked multi-byte conversion
MC/M           -            Masked single-byte conversion
MCN            ICONV/OCONV  Masked character numeric
MC/N           OCONV        Masked character exclude numeric
MCP            OCONV        Masked non-printable character conversion
MCT            OCONV        Masked initial capitals conversion
MCW            -            Masked wide character conversion
MCWX           ICONV/OCONV  Masked wide character to ASCII conversion
MCX            ICONV/OCONV  Hexadecimal to decimal conversion
MCXA           ICONV/OCONV  Character to 8-bit hexadecimal conversion
MCXD           ICONV/OCONV  Hexadecimal to decimal conversion
MCXW           ICONV/OCONV  Character to 16-bit (wide) hexadecimal conversion
MD             ICONV/OCONV  Masked decimal conversion
ML             ICONV/OCONV  Masked left conversion
MR             ICONV/OCONV  Masked right conversion
MM             -            NLS monetary conversion
MO             -            Octal conversion
MP             -            Packed decimal conversion
MT             ICONV/OCONV  Time conversion
MTS            ICONV/OCONV  Time conversion with seconds
MU0C           -            Hexadecimal Unicode character conversion
MX             ICONV/OCONV  Hexadecimal conversion
MY             OCONV        ASCII conversion
NL             -            NLS Arabic numeral conversion
NR             -            Roman numeral conversion
P              OCONV        Pattern-matching
Q              -            Exponential conversion
R              OCONV        Range function
S              OCONV        Soundex conversion
S;val;zeroval  OCONV        Substitution for non-zero values and zero values
T              OCONV        Text extraction
T<filename>    -            File translation
TI             -            International time conversion
U<hex>         OCONV        User exit to entrypoint <hex>. The specified entrypoint must be a hexadecimal number.
ZV             OCONV        Dynamic array element extraction